PowerBI dax measure

Lengkap Disiarkan 10 jam lepas Dibayar semasa penghantaran

$10-20 AUD

Dibayar semasa penghantaran

Lengkap Dibayar semasa penghantaran

I have dax problem, can be a simple one for experienced power bi person.

Basically, I have the ReportingMonth on slicer which is date column. and I have following measures.

Count Open this Month = CALCULATE(COUNT(TestData[ID]))

Count (Last Month) = CALCULATE([Count Open this Month],DATEADD('TestData'[ReportingMonth], -1,MONTH))

I have these values in KPI visual.

Now I need to replace ReportingMonth in slicer to below column.

Current/Snapshot Period =

IF(

TestData[ReportingMonth] = CALCULATE(max(TestData[ReportingMonth]), all(TestData)),

"Current Period",

FORMAT(TestData[ReportingMonth], "MMMM YYYY")

)

Which is text column.

Update "Count (Last Month)" measure so it can work when the slicer is changed to "Current/Snapshot Period" instead of reporting Month.

Attached the pbix for reference.

Power BI Excel Data Modeling

ID Projek: #38992469

Tentang projek

13 cadangan Projek jarak jauh Aktif 7 jam lepas

Mencari untuk memperoleh sedikit wang?

Kelebihan membida di Freelancer

Tetapkan bajet dan tempoh masa anda
Dibayar untuk kerja anda
Rangkakan cadangan anda
Ianya percuma untuk mendaftar dan membida pekerjaan

Dianugerahkan kepada:

Gambar Profil charingliu
charingliu

simple and little change on your "Count (Last Month)" measure, and will not change your other things but achieve your goal, also could help you have right sorting on 'Current/Snapshot Period' when placing on slicer.

$15 AUD dalam sehari
(1 Ulasan)
0.0
Gambar Profil eGeneraton2003
eGeneraton2003

Dear Client, Here is your solution as a complimentary. Please check the solution on given link. Our expertise in DAX and Power BI allows us to handle such modifications efficiently. We are highly experienced in this Lagi

$10 AUD dalam sehari
(0 Ulasan)
0.0

13 pekerja bebas membida secara purata $23 untuk pekerjaan ini

Gambar Profil anowarbss
anowarbss

Hi There, https://www.freelancer.com/projects/excel/Power-VBA-Automation-Expert?sb=t PowerBI dax Problem, As a professional and dedicated freelancer, I understand the value of accuracy. I have excellent command of MS W Lagi

$15 AUD dalam sehari
(42 Ulasan)
4.6
Gambar Profil bimzaman000
bimzaman000

Hey! I have gone through your description. I have done MS in statistics. I have experties on statistical analysis and data visualization. I have strong command on power BI. I can provide you the best quality work with Lagi

$20 AUD dalam sehari
(26 Ulasan)
4.6
Gambar Profil Asif031984
Asif031984

As a finance professional with over 15 years of experience, specializing in data analytics and visualization using tools like Power BI, I am confident that I can bring immense value to your project. Your requirement to Lagi

$20 AUD dalam 7 hari
(4 Ulasan)
4.5
Gambar Profil dynamopixel
dynamopixel

Hi, Let's transform your sales inquiry data into insightful, interactive visuals with ⭐ Power BI! Having over 7+ years of experience in ⭐ data analysis and visualization. ➡️ Here's how i can help: ● Design clear and Lagi

$20 AUD dalam sehari
(0 Ulasan)
0.0
Gambar Profil njahid1
njahid1

Expert in data visualization, programming, and analysis, focusing on EDA (Exploratory Data Analysis) and Machine Learning. Skills include: Power BI & Tableau: Create interactive dashboards and reports using DAX for cu Lagi

$30 AUD dalam 4 hari
(0 Ulasan)
0.0
Siarkan projek seperti ini