Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
eriweste
Helper I
Helper I

Compare with "where" and dateadd (same period last year)

Hi all,

 

Need assistant with creating a compare for values created this month with same period -1 year (last year)

- Im able to get the result when not using filters (where)

- Date columns exist

 

Goal

Create a dashboard that presents rows that differs more then 20 % (+ or -) from same period last year

This report are to be used to compare the data before the invoicing process starts

 

Dataset

eriweste_0-1662099532142.png

 

Need to compare (ex) the period Aug (08-22) with Aug (08-21)

 

The TSQL/ps1 would be like (simplified - do not laugh :))

$1 = Select _consumption where readingdate = Aug 2022 and quantitycodevalue = 'kvarh' and readingstatus = '2'

$2 = Select _consumption where readingdate = Aug 2021 and quantitycodevalue = 'kvarh' and readingstatus = '3'

 

if $1  $2 > Diff then 20 % of value of $1 = Display res 

 

(plz note that readingstatus differs (2 = Approved, 3 = Billed))

 

Any ideas

Br

erik

2 REPLIES 2
daXtreme
Solution Sage
Solution Sage

Have a look at this pattern.

Hi, 

Thanks for the reply. The DATE "issue" is handled (getting the correct period to compare)

 

Main issue is to correctly using the "where" perspective (filter), if not the SUM of all _consumptions are being presented. I need the individual rows to be compared (Kvarh, Hög, låg etc)

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.