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,
I have 3 columns Amt, Row Date and Column date.
I want to display the data as
Looking for a help on DAX formula, how to do it.
Hi @Anonymous
Can you please paste your sample data so we can make a measure that works perfectly for you.
I got this working, but need help on fine-tuning the formula.
Note:- I have more than 35M records in my table.
Def Revenue (M) =
VAR Month_Start = SELECTEDVALUE('Fact - Table'[recognition_Date])
VAR Earning = SELECTEDVALUE('Fact - Table'[earnings_Date])
VAR End_Date = CALCULATE(MAX('Fact - Table'[earnings_Date]), ALL('Fact - Table'))
RETURN
IF(Month_Start = Earning, "" ,
CALCULATE(
SUM('Fact - Table'[earnings_amount]),
'Fact - Table'[earnings_Date] > Month_Start
&& 'Fact - Table'[earnings_Date] >= Earning
&& 'Fact - Table'[earnings_Date] <= End_Date
)
)
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |