Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have the following measures for calculating Profit moving averages for current and last quarters:
Total Profits = [Total Sales]-[Total Costs]
Profits LQ = CALCULATE([Total Profits],DATEADD('Date'[Date],-1,QUARTER))
Now, when I am trying to insert 'Profits LQ' measure inside my "Profits 1M MA LQ", the Dax is not showing the 'Profits LQ' measure. And on top of this, I am getting a different measure symbol for my last quarter profit, unlike the other measures. I have inserted the image below.
Any help would be appreciated. Thanks.
@dax
please check that you created a measure and not a calculated column.
Yes, it was a major. But it worked fine after I closed and opened again my pbix file. This happens a lot with me don't know if there is a bug with the new update. Thanks.