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 Guys,
I know there ar emany simialr topics, but still cnanot solve it for my model.
I have a table with few columns - one is Due Date (date format from past year up to years in the future ) and one column Critical - with 1 or 0. I want to create a measure to :
calluclate the number of the Critical rows (=1) for the oeriod up to whateevr months (for exampel up to 2 months ).
I tired Calculate , or/and Filters, coutnrows, SUM etc, but with not good success . For example :
Solved! Go to Solution.
Hi @kmilarov ,
Your calculation should work with one minor change.
Instead of using 'Forecast_DB'[Due Date], you'll need use a date table.
Here are the steps I tried:
1. Follow 'Generate with Dax' instructions here
Create date tables in Power BI Desktop - Power BI | Microsoft Learn
I named by date table 'Dim_Date'
2. Join 'Forecast_DB'[Due Date] to 'Dim_Date'[Date]
3. Modify CRITs DAX to use Dim_Date
Hope this helps.
Thanks,
KhaiT
Hi @kmilarov ,
Your calculation should work with one minor change.
Instead of using 'Forecast_DB'[Due Date], you'll need use a date table.
Here are the steps I tried:
1. Follow 'Generate with Dax' instructions here
Create date tables in Power BI Desktop - Power BI | Microsoft Learn
I named by date table 'Dim_Date'
2. Join 'Forecast_DB'[Due Date] to 'Dim_Date'[Date]
3. Modify CRITs DAX to use Dim_Date
Hope this helps.
Thanks,
KhaiT
Thanks , KhaiT. Your suggestion works very well.
User | Count |
---|---|
77 | |
74 | |
60 | |
60 | |
46 |
User | Count |
---|---|
109 | |
95 | |
86 | |
79 | |
61 |