Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Experts
Here are my measures in order to calculate the previous months reports... but i am getting zero... when i have values for the previous month in the data set...
@Anonymous , you are using 'Test Data_'[IsCurrentYear] = TRUE (), if the max month is an , then you will get null
You can check without that or try all on date
Crime Report PM LM =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),
FILTER(
all('Test Data_'[cr03a_period]),eomonth('Test Data_'[cr03a_period],0)
=[Latest Month] -1 && 'Test Data_'[IsCurrentYear] = TRUE ()
)
)
Return
LatestMonthSum
or
Crime Report PM LM =
VAR LatestMonthSum =
CALCULATE ( SUM ( 'Test Data_'[cr03a_reportsmade] ),
FILTER(
('Test Data_'[cr03a_period]),eomonth('Test Data_'[cr03a_period],0)
=[Latest Month] -1
)
)
Return
LatestMonthSum
Neither formula are working
@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Hi Amit - did you get a chance to have a look at the sample data and question
Hi Amit the sample PBIC has Feb 21 data....
User | Count |
---|---|
95 | |
86 | |
78 | |
72 | |
66 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |