Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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 |
---|---|
90 | |
84 | |
66 | |
62 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
82 | |
71 |