Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in BI by (11.1k points)
How can I create dynamic date values?

1 Answer

0 votes
by (22.5k points)

Use the following DAX equation

Two Months Ago = CALCULATE ( SUM ( YourTable[Pos] ), PARALLELPERIOD ( YourTable[Month], -2, MONTH ) 
Compare = 
VAR CurrentMonth = SUM(YourTable[Pos])
VAR TwoMonthsAgo = CALCULATE(SUM(YourTable[Pos]),PARALLELPERIOD(YourTable[Month], -2, MONTH))
RETURN 

IF(CurrentMonth > TwoMonthsAgo, 'Higher', 'Lower') 

Want to learn more about Power Bi, Refer: Power Bi Training     

Related questions

0 votes
1 answer
asked Mar 28, 2021 in BI by Chris (11.1k points)
0 votes
1 answer
0 votes
1 answer
asked Feb 14, 2021 in BI by Chris (11.1k points)

Browse Categories

...