Search found 2 matches

by gs0706
Thu Apr 26, 2018 11:00 pm
Forum: Power BI Desktop/Service
Topic: Calculate a column help
Replies: 1
Views: 570

Calculate a column help

I want to populate each row of this table (NumDays) with the count of rows from this table that have the value of KEY1. I have this working by extrapolating the data from an additional table we added but I'd like to not have to do that. How do I do this?
by gs0706
Sat Feb 17, 2018 7:06 am
Forum: Power BI Desktop/Service
Topic: Using Parameters in IF-THEN-ELSE statements in PBI
Replies: 0
Views: 768

Using Parameters in IF-THEN-ELSE statements in PBI

I'm trying to figure out how to incorporate a parameter inside an IF-THEN-ELSE statement in PBI in order to 'calculate' different outcomes for specific times of the year (monthly, YTD and EOY). See current code (not in PBI obviously) below: Target Energy Month= IF (REPORT_MONTH EQ &REPORT_MONTH ...

Go to advanced search