Forum Discussion

grayFox's avatar
grayFox
Regular Visitor
6 years ago
Solved

Card Visuals -Time Intelligence

Hi All,  After some advice.  I have a calendar table and a sales table.  As there is a lag in reporting, I am unable to use the current month and previous month measures to report for these said m...
Need Help
Show and Tell
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi grayFox 

     

    you can use the below measures 

     

    Sales Last Month = 
CALCULATE(
    [Sales],
    PREVIOUSMONTH( 'Calendar'[Date] )
)
    Sales Last Month -1 = 
CALCULATE(
    [Sales Last Month],
    PREVIOUSMONTH( 'Calendar'[Date] )
)

     

     Later add Date column filter to your card visuals like below.

     

     

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

    Please feel free to connect with me.
    LinkedIn

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi grayFox 

 

you can use the below measures 

 

Sales Last Month = 
CALCULATE(
    [Sales],
    PREVIOUSMONTH( 'Calendar'[Date] )
)
Sales Last Month -1 = 
CALCULATE(
    [Sales Last Month],
    PREVIOUSMONTH( 'Calendar'[Date] )
)

 

 Later add Date column filter to your card visuals like below.

 

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

 

grayFox's avatar
grayFox
Regular Visitor
6 years ago

Hi Mariuz, 

Thanks so much, this worked. The solution was simpler than I thought!

One small tweak to make the suggestion work, I needed to change the filter as suggested from 'Day' to 'Month'