The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
See the different measure symbol from the rest.
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.
User | Count |
---|---|
16 | |
8 | |
7 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
12 | |
8 | |
8 |