Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
HI,
I am very new to power bi. acutally i am trying to convert TABLEAU app into power bi.
in a chart there is caluclated dimension created as below
{ FIXED [Year Week]: MAX([End Time])}
Year Week is year and week from a date field
so to do this power bi i did as follows
Year Week = FORMAT([end_time].[Date],"yyyy")&WEEKNUM([end_time].[Date],2) ---> in text format
And for { FIXED [Year Week]: MAX([End Time])} i did below
CALCULATE(MAX([end_time].[Date]),ALL(Year Week)) ---->date format
but not getting the output
can anyone help me on this
Hi,
I'm very new to tableau,
I'm migrated this form of tableau for Power BI
in a collum of table there is calculated dimension created as below
Vda Forn Cat
{ FIXED [Regiao IM], [Nome Fabricante], [Nome Categoria], [Mercado] : SUM([Vendas Valor])}
so to do this power bi i did as follows:
I believe what you want is:
CALCULATE(MAX([end_time].[Date]),ALLEXCEPT([Year Week]))
My understanding of FIXED is that it in your case your formula will calculate MAX of [End Time] in the context of [Year Week] regardless of any other dimensions in the view.
The equivalent of that should be ALLEXCEPT in that ALLEXCEPT removes all context other than those specified in the function.
Thanks for the reply
by using this
CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))
i am getting only one value
31/dec/2016
and above calcluation i am using as dimension.
can you check this
Thanks
Hi @arulsettu,
>>i am getting only one value
If you only drag this measure to a visual, you will get the max date. You can add other columns to work through this issue.
Regards,
Xiaoxin Sheng
i am using this as dimension
CALCULATE(MAX([end_time].[Date]),ALLEXCEPT('table_name',[Year]))
and
count(value)
so where and what should i add as anew column
Hi @arulsettu,
You should add a index column to let the measure calculate loop the table.
For example:
Notice: Count(value) will summarize this field
Regards,
Xiaoxin sheng
i am doinglike below is this correct
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |