The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
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)
User | Count |
---|---|
26 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
28 | |
13 | |
12 | |
12 | |
6 |