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.
HI all.
I have the next issue:
I got a table of sales whith a different granularity and a budget table.
So, i have a dax formula for the (Us Fcst) day and MTD budget and its ok.
The problem here is MTD Us fcst its doesnt work in the matrix but the MTD_Us its worked.
And, i need a QTD and YTD BUDGET for the KPI and the matrix whith no filters of date.
You can get the sample data here
Please someone help me!!!
Sorry by my text...
Hi,
I cannot understand your question. Show some data and the expected result.
I can't say i fully understand what you are trying to do, but from what I can read it seems like you answer will be to use a Date Table. This would allow you to flag dates with additional groupings such that you could use them in filter or grouping context.
One example is having a Quarter column in the date table, which assigns Q1, Q2, Q3 or Q4 on each date row. You could next have a column which is QuarterYear which is a concatination of the Quarter value and the Year number. This would let you uniquely group different quarters from different years.
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 |
---|---|
100 | |
100 | |
80 | |
77 | |
66 |
User | Count |
---|---|
134 | |
106 | |
104 | |
85 | |
73 |