Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
DAX behavior for each formula is different.
I want to calculate Last Year MTD , By default without any slicer selection the function should take Today's date(Last Year) as end of date and calculate sum. If users choose any selection it should take that date as End of date(Last Year)
Fourth Screen shot with 3rd Date selection – LYMTD and Previous Year MTD Total are showing up correct with calculation from Oct 1st to Oct 3rd 2015 and PY MTDSALES is totally wrong/incorrect
I have 3 columns "Month" & "Achievement" & "Location" that I need to create 1 calculated column to get "Average Number" from "Achievement" column using all location but in every month separated
The average should be like the table below but I can't get the number with DAX.
Kindly any advice
Month | Achievement | Location | Average |
1/1/2017 | 80 | 101 | 85 |
1/1/2017 | 90 | 102 | 85 |
2/1/2017 | 20 | 103 | 40 |
2/1/2017 | 60 | 105 | 40 |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
26 | |
20 | |
19 | |
14 | |
13 |
User | Count |
---|---|
44 | |
36 | |
24 | |
24 | |
22 |