Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Solved! Go to Solution.
Hi @Ste_For94 ,
Use the below measures.
Hi @Ste_For94 ,
Use the below measures.
Thanks @harshnathani I think this should work! still I'm having problems in implementing what you did and all I'm getting is an empty table... did you link somehow the calendar table to the incident table? if so how? (join, relation...)
also where should i build my measures, into the incident or the calendar table?
thank you, sorry to bother 🙂
Stefano
Created a Calendar Table.
yep done that already, I made a mistake in selecting the filter field...
and then the numbers were not adding up because if say i select only years and months it does not work unless i modify the measure like this:
Hi @Ste_For94
Unfortunately, the information you provided is not enough to provide help.
1. Do you need those 3 columns in the same fact table or you want to build a virtual one in Power BI?
2. Do you have a separate calendar table and if you do, what relationship is the active one: Data_Ins or Data_Risol?
It would be best if you provide a sample table with desired output.
But still you can adopt the following pattern:
VAR MaxDate =
MAX ( 'Calendar'[Date] ) -- saves the last visible date
VAR DesiredTable =
ADDCOLUMNS (
VALUES ( 'Calendar'[Date] ),
"Open Cases", CALCULATE (
COUNTROWS ( 'FactTable' ),
FILTER ( VALUES ( 'FactTable'[State] ), 'FactTable'[State] = "Open" ),
FILTER ( ALL ( 'Calendar' ), 'Calendar'[Date] <= MaxDate )
)
)
RETURN
DesiredTable
This code returns a table, so you can use it in PowerBI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |