Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello, I have simple two table i.e. FactTable and Calendar. Calendar table is marked as date table too.
I am try to calculate QTD and YTD total but formula simply doesn't work. Any help please? I am new in PowerBI
.
Trxn:=sum([Amount])
Actual Trxn QTD:=CALCULATE([Trxn],DATESQTD(Calendar[Date]))
Actual Trxn YTD:=CALCULATE([Trxn],DATESYTD(Calendar[Date]))
Kind regards, Satyapal
Solved! Go to Solution.
Hello,
Thank you for the answer.
I don't know what was the exact problem but I simply remove the relationship first and then re build relationship and it worked.
Thank you
Please try it in Apr 2017 version of Power BI Desktop. You need to create relationship between Calendar and FactTable with Date key. The measure you provided should work in Table visual as below.
Please refer to attached PBIX file.
Best Regards,
Herbert
Hello,
Thank you for the answer.
I don't know what was the exact problem but I simply remove the relationship first and then re build relationship and it worked.
Thank you
This could be related to your version of Excel... I seem to remember these functions only working in later versions?
What Excel are you using? I note you have the "backwards" filter arrows so it must be 2013 or less?
Cheers
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |