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 Experts,
I am finding an issue to get the result below. Attached is the data set.
Please help me.
Attaching the .pbix file.
Invoiced Amount = Total Amount Based on Customer Number for the current Date and for future dates it should display Closing value of the previous date (As per the below screenshot)
Please suggest any DAX changes are any modeling changes that need to be applied.
Please someone help me on this data issue??
@Anonymous , With help from date table, You can create measures liek example and in matrix you have use "Show on row"
example
This Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])))
Last Day = CALCULATE(sum('order'[Qty]), FILTER(ALL('Date'),'Date'[Date]=max('Date'[Date])-1))
Last Day = CALCULATE(sum('order'[Qty]), previousday('Date'[Date]))
Day behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-1,Day))
Show on row : https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Help me how to upload the .pbix file here?
https://drive.google.com/file/d/1khHKtct-Fa4cDTFVHfH5Z_BIS6ecfxv8/view?usp=sharing
Link to download .pbix file
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 |
---|---|
43 | |
23 | |
21 | |
15 | |
15 |
User | Count |
---|---|
45 | |
31 | |
30 | |
18 | |
17 |