Forum Discussion
How to get the additional fields in table depending on variable ?
Hi All ,
I am transforming Qliksense App to Power Bi App.
Can anyone please help how to approach - I have to create a variable - vTMP_Max_Date
MaxDate:
Load Max(_Date) as _MaxDate
Resident PH;
LET vTMP_Max_Date = Num(Peek('_MaxDate', 0, 'MaxDate'));
After creating the variable vTMP_Max_Date
I need to add the following field in the current table which is created by evaluating the variable vTMP_Max_Date
Join(PH)
load distinct _Date,
Interval($(vTMP_Max_Date) - _Date,'d') As PH.Last_n_days,
if(Interval($(vTMP_Max_Date) - _Date,'d') =0,1,0) as PH.count_today,
if(Interval($(vTMP_Max_Date) - _Date,'d') =7,1,0) as PH.count_7_days_ago
resident PH
;
Currently I have the PH table with below columns
I want to get the columns
PH.Last_n_days,
PH.count_today,
PH.count_7_days_ago like below
1 Reply
suvechha Sorry, I don't speak Qliksense. These things usually go faster if you just post sample data and expected output.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
