Forum Discussion
Solved
Create custom text based date on X axis
Hi BI folks, Im looking our for a ideal / best approaches to handle below type of visual requirement in purely Power BI or SQL code. How to build the data view for this? In the mockup i...
since we don't have the fact table, i can only create the date table for testing.
pls see the attachment below
Hi Team,
Currently my fact model looks like below:
date, kpi name, few dimensions, Units (sum/divide), value , value 1.
my generic calculation: if the Units = 'sum' then sum(value) else sum(value)/ sum(value1)
Also for the above case of scenario should I create a disconnected table approach?
Help me with the steps please. Thanks!