Forum Discussion
DAX Queries
In my Power BI Report I'm having,
Month Value
August 1,24,000
September 2,46,789
October 8,49,000
November 2,04,985
December 90,485
Now, I want to display the value of all the months to above 8,00,000 through DAX Queries. How can I do that.
Anonymous
You can create a calculated table like below:
Table = FILTER(ALL(Table1[Month]),CALCULATE(SUM(Table1[Value]))>800000)
Regards,
1 Reply
v-sihou-msftMicrosoft Employee
Anonymous
You can create a calculated table like below:
Table = FILTER(ALL(Table1[Month]),CALCULATE(SUM(Table1[Value]))>800000)
Regards,